PlStudentPlacement 
Logical Entity Name  PlStudentPlacement 
Default Table Name  PlStudentPlacement 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

PlStudentPlacement Columns 
ColumnName  Domain  Datatype  NULL  Definition 
PlStudentPlacementID(PK)    int  NO 
 
PlStudentID(FK)    int  NO 
 
PlEmployerID(FK)    int  NO 
 
PlEmployerJobID(FK)    int  YES 
 
PlJobTitleID    int  YES 
 
Descrip    varchar(2000)  YES 
 
Status    char(1)  NO 
 
DatePlaced    datetime  YES 
 
StartDate    datetime  YES 
 
Supervisor    varchar(35)  YES 
 
Comment    varchar(2000)  YES 
 
InFieldOfStudy    char(1)  NO 
 
Salary    money  YES 
 
SalaryType    char(1)  YES 
 
FromInterview    bit  NO 
 
Benefits    bit  NO 
 
Fee    bit  NO 
 
JobSchedule    char(1)  YES 
 
PlRepID    int  YES 
 
TermDate    datetime  YES 
 
TermReason    varchar(400)  YES 
 
UserID    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
AdEnrollSchedID    int  YES 
 
Converted    bit  YES 
 
Current    bit  YES 
 
EndDate    datetime  YES 
 
SchedFrom    char(35)  YES 
 
SchedTo    char(35)  YES 
 
PlHowPlacedID    int  YES 
 
PlJobTypeID    int  YES 
 
VerifAgent    char(60)  YES 
 
VerifAgentPhone    char(16)  YES 
 
VerifAgentTitle    varchar(50)  YES 
 
VerifComment    varchar(255)  YES 
 
VerifDate    datetime  YES 
 
VerifPLRepID    int  YES 
 
SupervisorPhone    varchar(16)  YES 
 
PlJobSourceID    int  YES 
 
ExactJobTitle    varchar(100)  YES 
 
PlJobCategoryID(FK)    int  YES 
 

PlStudentPlacement Primary and Unique Keys 
Key Name  Key Type  Keys 
PlStudentPlacement_PlStudentPlacementID_U_C_IDX  PrimaryKey  PlStudentPlacementID 

PlStudentPlacement Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
PlEmployer  Non-Identifying  One To Zero or More  FK_PlStudentPlacement_PlEmployerID_PlEmployer_PlEmployerID      PlEmployerID  NO  YES 
PlEmployerJob  Non-Identifying  Zero or One to Zero or More  FK_PlStudentPlacement_PlEmployerJobID_PlEmployerJob_PlEmployerJobID      PlEmployerJobID  NO  YES 
PlJobCategory  Non-Identifying  Zero or One to Zero or More  FK_PlStudentPlacement_PlJobCategoryID_PlJobCategory_PlJobCategoryID      PlJobCategoryID  NO  YES 
PlStudent  Non-Identifying  One To Zero or More  FK_PlStudentPlacement_PlStudentID_PlStudent_PlStudentID      PlStudentID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
CmDocument  Non-Identifying  One To Zero or More  FK_CmDocument_PlStudentPlacementID_PlStudentPlacement_PlStudentPlacementID        NO  YES 
PlStudentPlacementVerification  Non-Identifying  One To Zero or More  FK_PlStudentPlacementVerificationPlStudentPlacementId_PlStudentPlacementPlStudentPlacementId        NO  YES 
PlStudentSalary  Non-Identifying  One To Zero or More  FK_PlStudentSalary_PlStudentPlacementID_PlStudentPlacement_PlStudentPlacementID        NO  YES 

PlStudentPlacement Check Constraints 
Check Constraint Name  CheckConstraint 

PlStudentPlacement Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

PlStudentPlacement Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentPlacement 
NO       
Physical (Microsoft SQL Server)
dbo.PlStudentPlacement 
NO       

PlStudentPlacement Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Documents 
Logical  StudentJobPlacement 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Placement 

PlStudentPlacement Data Movement Rules 
Name  Type  Rule Text/Value